Stored Procedures [dbo].[aspnet_CheckSchemaVersion]
Properties
PropertyValue
ANSI Nulls OnNo
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Featurenvarchar(128)256
@CompatibleSchemaVersionnvarchar(128)256
Permissions
TypeActionOwning Principal
GrantExecuteaspnet_Membership_BasicAccess
GrantExecuteaspnet_Membership_ReportingAccess
GrantExecuteaspnet_Profile_BasicAccess
GrantExecuteaspnet_Profile_ReportingAccess
GrantExecuteaspnet_Personalization_BasicAccess
GrantExecuteaspnet_Personalization_ReportingAccess
SQL Script
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].aspnet_CheckSchemaVersion
    @Feature                   nvarchar(128),
    @CompatibleSchemaVersion   nvarchar(128)
AS
BEGIN
    IF (EXISTS( SELECT  *
                FROM    dbo.aspnet_SchemaVersions
                WHERE   Feature = LOWER( @Feature ) AND
                        CompatibleSchemaVersion = @CompatibleSchemaVersion ))
        RETURN 0

    RETURN 1
END
GO
GRANT EXECUTE ON  [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Membership_BasicAccess]
GRANT EXECUTE ON  [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Membership_ReportingAccess]
GRANT EXECUTE ON  [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Personalization_BasicAccess]
GRANT EXECUTE ON  [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Personalization_ReportingAccess]
GRANT EXECUTE ON  [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Profile_BasicAccess]
GRANT EXECUTE ON  [dbo].[aspnet_CheckSchemaVersion] TO [aspnet_Profile_ReportingAccess]
GO
Uses